select c.speciality_name, count(*) from persons p, specialitys c where p.reg_no>0 and c. speciality_id=p.speciality_id group by speciality_name